Querying Rdf Data Stored in Dbms: Sparql to Sql Conversion
نویسنده
چکیده
This paper discusses the design and implementation of a tool for SPARQL to SQL conversion. The converter receives a SPARQL query which is then parsed and analyzed. All three current approaches to storing RDF data in RDMS (triple store, property tables, and vertical partitioning) are supported in this paper. Depending on the tool's configuration one of these methods is chosen and a proper SQL query is generated. After executing the SQL query and getting rows back from the database, the tool converts the result into SPARQL XML format. In the end this result is returned as an answer to the initial SPARQL query. The converter was evaluated using UniProt data (16.6 million triples) and real world SPARQL queries. The performance study included both the comparison of all RDF storing approaches and the analysis of the overhead of the conversion between SPARQL and SQL.
منابع مشابه
Optimizing Unbound-property Queries to RDF Views of Relational Databases
SAQ (Semantic Archive and Query) is a system for querying and long-term preservation of relational data in terms of RDF. In SAQ relational data in a back-end DBMS is exposed as an RDF view, called the RD-view. SAQ can process arbitrary SPARQL queries to the RD-view. In addition long-term preservation as RDF of selected parts of a relational database is specified by SPARQL queries to the RD-view...
متن کاملRDQuery - Querying Relational Databases on-the-fly with RDF-QL
One of the main drawbacks of the Semantic Web is the lack of semantically rich data, since most of the information is still stored in relational databases. We present RDQuery, a wrapper system which enables Semantic Web applications to access and query data actually stored in relational databases using their own built-in functionality. RDQuery automatically translates SPARQL and RDQL queries in...
متن کاملHeuristic Optimization of SPARQL queries over Column-Store DBMS
During the last decade we have witnessed a tremendous increase in the amount of semantic data available on the Web in almost every field of human activity. More and more corporate, governmental, or even user-generated datasets break the walls of “private” management within their production site, are published, and become available for potential data consumers, i.e., applications/services, indiv...
متن کاملRDF triples management in roStore RDF triples management in roStore
Résumé : This paper tackles issues encountered in storing and querying services dealing with information described with Semantic Web languages, e.g. OWL and RDF(S). Our work considers RDF triples stored in relational databases. We assume that depending on the applications and queries asked to RDF triple stores, different partitioning approaches can be considered : either storing all triples in ...
متن کاملAn efficient SQL-based querying method to RDF schemata
Applications based on knowledge engineering require operations on semantic data. Traditionally, in this area relational data are transformed to a form expected by a reasoning system (usually RDF). In this work a method is presented that transforms a query to a RDF data structure (i.e. SPARQL) to a SQL query executed by RDBMS. This could lead to significant increase to efficiency of reasoning. O...
متن کامل